USE [MusicLine]
GO

CREATE PROCEDURE LookupCutsByArtist
    @ArtistName varchar(100)
AS
    SELECT  C.AlbumId, C.CutNumber, C.Title, C.LengthInSeconds
    FROM    Cuts C
    INNER JOIN Albums A ON A.AlbumId=C.AlbumId
    INNER JOIN Artists Ar ON Ar.ArtistId=A.ArtistId
    WHERE   Ar.Name LIKE '%' + @ArtistName + '%'